Listing 7 shows an example of a stored procedure that determines an employee's new salary and bonus, depending on their performance rating.
清单7展示了一个存储过程的例子，该存储过程根据业绩评分评定雇员新的工资和奖金。
This stored procedure accepts two input parameters, the employee number and a rating, then updates the employee's salary and bonus depending on the rating given.
该存储过程接受两个输入参数，即雇员号和一个评分，然后根据给定的评分更新该雇员的工资和奖金。
Monthly evaluate the operator's performance bonus according to the appraisal management procedure to correct the operator's behavior and develop their performance.
执行员工的绩效奖金评估程序，及时纠正员工的不正确行为，并持续改进。
应用推荐